UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eFaNUOFzdRVfmoSpWMD/sz8JvI9Jhit7qpyZ1xYEpB0='
WHERE
key_id = '20bc2b7d4db44a56e8976e0ed316ad146d90caa801a46d1ed9476ed7420aebd6'
AND (
token = 'eFaNUOFzdRVfmoSpWMD/sz8JvI9Jhit7qpyZ1xYEpB0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)