UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G45CzOfY9+7rouoaWC6Ejbw4aI6+EX14p/0Gry5qIms='
WHERE
key_id = 'd1b4c832a46405f54c43fb71b19492108182a58ad73822ad28dcfaffc281671e'
AND (
token = 'G45CzOfY9+7rouoaWC6Ejbw4aI6+EX14p/0Gry5qIms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)