UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'otPN5fFFg1h26RqIlWEnApogBqG/v4YpP+hYI3IEKAE='
WHERE
key_id = '138d5bf0677ffeb07d003d3fc151f9166cd4ae4e8bf03eac1e8a3b7d46f4320e'
AND (
token = 'otPN5fFFg1h26RqIlWEnApogBqG/v4YpP+hYI3IEKAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)