UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NbAGY2MHxoNGTtGvkTsLkjn6ubM2XlrRjH7C1imPREo='
WHERE
key_id = 'c75e18fd0477d44258e3f71f90443f34ddd2fcc5012da84616c8af6040a01e91'
AND (
token = 'NbAGY2MHxoNGTtGvkTsLkjn6ubM2XlrRjH7C1imPREo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)