UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0HMXwp/j6CDrpGrvYlk8DLVJcj4qHHHihzZQsgjAJZA='
WHERE
key_id = '47069fda3da82952bbb34c3b3522a61f0d4c18fabaa44d23450a549640738606'
AND (
token = '0HMXwp/j6CDrpGrvYlk8DLVJcj4qHHHihzZQsgjAJZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)