UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfjCJdC4tCqGpy6WpG1BX7r0F5OsfDa1roKrcppIDLc='
WHERE
key_id = '9aa4198b044eca40dc18061ae72b6b9fad47d4b11a79d44e644317d5dbc151ce'
AND (
token = 'xfjCJdC4tCqGpy6WpG1BX7r0F5OsfDa1roKrcppIDLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)