UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CW7DYbCnfe6AqX03AY89K0tLM1txHLSWUmV/fz9zrX0='
WHERE
key_id = 'dceee8bd837ac60fc50e6b620d023ca478848d4b73a11e8ee6e5ab9310507e23'
AND (
token = 'CW7DYbCnfe6AqX03AY89K0tLM1txHLSWUmV/fz9zrX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)