UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f6r4SQUFiBILRDWdFwV0IYgDwm0DhoOBb1WcsldAXB4='
WHERE
key_id = '17be3caf412fa1d01c6f2fb1b421b005b97d8894d2fe7e39029193115038e953'
AND (
token = 'f6r4SQUFiBILRDWdFwV0IYgDwm0DhoOBb1WcsldAXB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)