UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c7dpbJ749UAiWLI+epqwq/frywYViQ6Uwik6txuFmpM='
WHERE
key_id = 'a13ff96abac0a63688eb9cf0de70acbc0a1a36f7c05b4db7ce69da7faed6f57d'
AND (
token = 'c7dpbJ749UAiWLI+epqwq/frywYViQ6Uwik6txuFmpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)