UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8lDHSoWygZnu0Fu4Yhagq4gw4wUKDT+P/i90KmqCcbo='
WHERE
key_id = 'cc39ff2efbf26d1ee1f08181f42d0b733ae510797d2175268161b55d32ad7035'
AND (
token = '8lDHSoWygZnu0Fu4Yhagq4gw4wUKDT+P/i90KmqCcbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)