UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xINr6XmJlv4TpQZr+bjxsFwCZGj15ni5gRXn4hUg6xY='
WHERE
key_id = '7e2ec5b5b42a044529378cf284fe960d88e3330ebb751f9f314e3991bcf6a6ad'
AND (
token = 'xINr6XmJlv4TpQZr+bjxsFwCZGj15ni5gRXn4hUg6xY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)