UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OxRlp9kEw9JnNB6IFqQ9z75Vp8D8f4SNeOs7zKzvwWE='
WHERE
key_id = 'd5d8a3939213f0e07578b6d2876738d7022cfefce66024eb15cdf775d63e131d'
AND (
token = 'OxRlp9kEw9JnNB6IFqQ9z75Vp8D8f4SNeOs7zKzvwWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)