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