UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qgkSvas6BNe8mL+ibSJiLNGghid4371VZeA4i9DPaqA='
WHERE
key_id = 'a78e4cf1ba1d78cd3acbdc659c72615adc68c5c38ecf28b8e4ac3e302b50a6eb'
AND (
token = 'qgkSvas6BNe8mL+ibSJiLNGghid4371VZeA4i9DPaqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)