UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3nm5qk57h2tjNY0blMtHl/FT2ad+GIefJPqY5bJ2KHc='
WHERE
key_id = '4ce6f27988c3130ca535f95576e1ce462ee2b39c03700449927f990c47ce0793'
AND (
token = '3nm5qk57h2tjNY0blMtHl/FT2ad+GIefJPqY5bJ2KHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)