UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tJeA4FtPrsA05bJKTYucD4pDZSkNr40bp00lztWhLeI='
WHERE
key_id = '5f17931ed425c52b5d0750cb2c656a6a35894d9c90e3df4f4a31de8111ff0a8e'
AND (
token = 'tJeA4FtPrsA05bJKTYucD4pDZSkNr40bp00lztWhLeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)