UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aSzfPSirGP8nWzdKZN8caOnzxdVMuGsZWnA1bVMD7uU='
WHERE
key_id = '56965fc2337087e024c233eb258db994fb850f1b755de9d1272e7a7554308c6f'
AND (
token = 'aSzfPSirGP8nWzdKZN8caOnzxdVMuGsZWnA1bVMD7uU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)