UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xs0ayJJIUt4855KaTN9x1nYseX+Cgj9aU6NWWSFfdHg='
WHERE
key_id = '862aa5319101bc858c08b76c4b5d9b112c4e02298b30063c159ba0d8812d38ea'
AND (
token = 'xs0ayJJIUt4855KaTN9x1nYseX+Cgj9aU6NWWSFfdHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)