UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VrZNILkMFeGRsgxMTnZ1VEMQWBOzIYStcCSjQGwRjSE='
WHERE
key_id = '4c86921886425b47c2cd33d8cc147ed1c7d722cd50f518261826a6df977e54f1'
AND (
token = 'VrZNILkMFeGRsgxMTnZ1VEMQWBOzIYStcCSjQGwRjSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)