UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '40bu9OjTG/ISmKZe6x49nYcF81AnV8DmKRl521INxro='
WHERE
key_id = '03a7eaf6a77d9eeac966c0daae8bab33c20bc8eae9860293bfcd724f473f348e'
AND (
token = '40bu9OjTG/ISmKZe6x49nYcF81AnV8DmKRl521INxro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)