UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OWVZBWch2iF9PrMX3vz8dbLjuFFw/d7fyG7hTWBggT8='
WHERE
key_id = '15f170cf022e0538ce006b56ebca03c330c305e934f5fe324bfa31841930783f'
AND (
token = 'OWVZBWch2iF9PrMX3vz8dbLjuFFw/d7fyG7hTWBggT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)