UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cZthJdwKPzL4XVteT+OgH24EeNF+sa7/s2T0qQ2eN8w='
WHERE
key_id = 'b9edd37a975e5110686bda5887e9f59e91378bca64664351abb2c16b4f08607f'
AND (
token = 'cZthJdwKPzL4XVteT+OgH24EeNF+sa7/s2T0qQ2eN8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)