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