UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kG0AmeXB7ZJrDs4mP0CeaVOoUwxUSo5P5DZnRKyohNQ='
WHERE
key_id = '9e4472d600f27b24bd8e205a25e6e0bfac18fe311d989140e6e1f0d5c88787e7'
AND (
token = 'kG0AmeXB7ZJrDs4mP0CeaVOoUwxUSo5P5DZnRKyohNQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)