UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ESU62Lv6jgO/7tAZuJer8y+7jMll/OHMiHwSYg3YnI='
WHERE
key_id = '5eae3b5dbb1b602555427d774e22d6a40b61dd636f349114011040f8b487a34e'
AND (
token = '0ESU62Lv6jgO/7tAZuJer8y+7jMll/OHMiHwSYg3YnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)