UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pn4idX8r1DIfU7jWBQRvAcYF8T+WyCZe7YSFMgLoDQw='
WHERE
key_id = 'd66bbb6968b3727ecf7521ab26eb5675bfee99eb8903af8a733d927a78d4f8fd'
AND (
token = 'Pn4idX8r1DIfU7jWBQRvAcYF8T+WyCZe7YSFMgLoDQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)