UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CH1dw6NWqcUZqeK63eYX663P1AIKVB3Ib+JxKePwIUs='
WHERE
key_id = 'ce7df4152ebac934ec9e99e912f155f1f6acf2db4886bc86b8805c743afa24c9'
AND (
token = 'CH1dw6NWqcUZqeK63eYX663P1AIKVB3Ib+JxKePwIUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)